package com.wmh.baseservice.operationaid.excel;

import com.alibaba.excel.annotation.ExcelProperty;
import com.fasterxml.jackson.annotation.JsonFormat;
import com.wmh.baseservice.operationaid.excel.convert.LocalDateTimeConverter;
import com.wmh.baseservice.operationaid.excel.convert.AddSymbolConverter;
import com.wmh.baseservice.operationaid.excel.convert.PercentageConverter;
import lombok.Data;
import lombok.EqualsAndHashCode;

import java.math.BigDecimal;
import java.time.LocalDateTime;

@Data
@EqualsAndHashCode
public class PddStoreExcel {

    /**
     * 店铺名称
     */
    @ExcelProperty("店铺名称")
    private String storeName;

    /**
     * 数据日期
     */
    @ExcelProperty(value = "数据日期", converter = LocalDateTimeConverter.class)
    @JsonFormat(pattern = "yyyy-MM-dd")
    private LocalDateTime dataDate;

    /**
     * 店铺总销售额
     */
    @ExcelProperty("店铺总销售额")
    private BigDecimal totalStoreSales;

    /**
     * 刷单金额
     */
    @ExcelProperty("刷单金额")
    private BigDecimal brushOrdersAmount;

    /**
     * 真实额 1
     */
    @ExcelProperty("真实额1")
    private BigDecimal realAmountOne;

    /**
     * 退款金额
     */
    @ExcelProperty("退款金额")
    private BigDecimal refundAmount;

    /**
     * 真实额 2
     */
    @ExcelProperty("真实额2")
    private BigDecimal realAmountTwo;

    /**
     * 真实订单数
     */
    @ExcelProperty("真实订单数")
    private Integer realOrderNum;

    /**
     * 客单价
     */
    @ExcelProperty("客单价")
    private BigDecimal customerUnitPrice;

    /**
     * 订单总数
     */
    @ExcelProperty("订单总数")
    private Integer totalOrders;

    /**
     * 补单订单数
     */
    @ExcelProperty("补单订单数")
    private Integer supplementaryOrders;

    /**
     * 免费送
     */
    @ExcelProperty("免费送")
    private Integer freeDelivery;

    /**
     * 访客
     */
    @ExcelProperty("访客")
    private Integer visitor;

    /**
     * 转化率
     */
    @ExcelProperty(value = "转化率" , converter = AddSymbolConverter.class)
    private BigDecimal conversionRate;

    /**
     * 补单佣金加快递
     */
    @ExcelProperty("补单佣金加快递")
    private BigDecimal supplementaryCommissionExpress;

    /**
     * 多多搜索
     */
    @ExcelProperty("多多搜索")
    private BigDecimal duoduoSearch;

    /**
     * 搜索成交
     */
    @ExcelProperty("搜索成交")
    private BigDecimal searchDeal;

    /**
     * 多多场景
     */
    @ExcelProperty("多多场景")
    private BigDecimal duoduoScene;

    /**
     * 场景成交
     */
    @ExcelProperty("场景成交")
    private BigDecimal sceneDeal;

    /**
     * 明星店铺推广
     */
    @ExcelProperty("明星店铺推广")
    private BigDecimal starStorePromotion;

    /**
     * 明星店铺成交
     */
    @ExcelProperty("明星店铺成交")
    private BigDecimal starStoreDeal;

    /**
     * 全站推广
     */
    @ExcelProperty("全站推广")
    private BigDecimal websitePromotion;

    /**
     * 全站推广成交
     */
    @ExcelProperty("全站推广成交")
    private BigDecimal websitePromotionDeal;

    /**
     * 推广 ROI
     */
    @ExcelProperty("推广 ROI")
    private BigDecimal promoteRoi;

    /**
     * 广告费占比
     */
    @ExcelProperty(value = "广告费占比", converter = PercentageConverter.class)
    private BigDecimal proportionOfAdvertisingExpenses;

    /**
     * 领航员综合分行业排名
     */
    @ExcelProperty(value = "领航员综合分行业排名", converter = AddSymbolConverter.class)
    private BigDecimal comprehensiveScoreIndustryRanking;

    /**
     * 求助率
     */
    @ExcelProperty(value = "求助率（近30天）", converter = AddSymbolConverter.class)
    private BigDecimal helpRate;

    /**
     * 总订单数（近30天）
     */
    @ExcelProperty("总订单数（近30天）")
    private Integer totalOrdersLastThirtyDays;

    /**
     * 刷单订单数（近30天）
     */
    @ExcelProperty("刷单订单数（近30天）")
    private Integer supplementaryOrdersLastThirtyDays;

    /**
     * 免费送订单数（近30天）（近30天）
     */
    @ExcelProperty("免费送订单数（近30天）")
    private Integer freeDeliveryLastThirtyDays;

}
